MacWorld 1996 July

home *** CD-ROM | disk | FTP | other *** search

/ MacWorld 1996 July / Macworld (1996-07).dmg / System 7.5 Update 2.0 / FileMaker Pro 3.0 CD Extras / FileMaker Examples / Templates w⁄data / Business / Timecards (.txt) < prev

Wrap

FileMaker Pro Database | 1996-01-25 | 106KB | 715 lines

HBAM2016AUG95 Pro 3.0 DAY FLAG 3 HBAM3016AUG95@ HP DeskJet 540 Printer 11/10/95 llustrates some of the power features of ScriptMaker. On launch, a startup script checks to see if a record currently exists for this week. If not, one is created, calculating the day the week started, then finding the correct starting time field on the correct line for today. If a current record already exists for this week, the script figures out what day today is, and goes to that line of the start time repeating field. Note that the script correctly figures out the d Sunday Monday Tuesday Wednesday Thursday Friday Saturday January February March April August September October November December 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter $Q@g* 1/22/96 BEGIN WEEK COMMENTS CURRENT WEEK DAY FLAG 1 DAY FLAG 2 A Form View @#A List View Information Report Menu Timecard Form A Form ViewB DAY FLAG 3 DAY FLAG 4 DAY FLAG 5 DAY FLAG 6 DAY FLAG 7 DAY NAME 1 DAY NAME 2 DAY NAME 3 DAY NAME 4 DAY NAME 5 DAY NAME 6 DAY NAME 7 DAY TYPE EMPLOYEE ID END TIME END WEEK FIRST NAME HOURS LEFT # LAST NAME LUNCH HOURS MARK CHARACTER START TIME TODAY'S DATE TODAY'S DAY NAME TOTAL HOURS WEEK START DAY WORK HOURS WORK WEEK HOURS Begin WeekB End WeekB Today's DateB Start TimeB Lunch HoursB End TimeB Work HoursB ) + ) / 60 - Day TypeB Day Name 1B Day Name 2B + 1) Day Name 3B + 2) Day Name 4B + 3) Day Name 5B + 4) Day Name 6B + 5) Day Name 7B + 6) Total HoursB Hours LeftB CommentsB Current WeekB Week Start DayB ) = "Monday" ) = "Tuesday" ) = "Wednesday" ) = "Thursday" ) = "Friday" ) = "Saturday" ) = "Sunday" - 6) Monday Tuesday Wednesday Thursday Friday Saturday Sunday Day Flag 1B Day Flag 2B Day Flag 3B Day Flag 4 Day Flag 5B Day Flag 6B Day Flag 7B First NameB Employee IDB Today's Day NameB Mark CharacterB InfoB Work Week HoursB %A Last NameB 11/20/95 This template illustrates some of the power features of ScriptMaker. On launch, a startup script checks to see if a record currently exists for this week. If not, one is created, calculating the day the week started, then finding the correct starting time field on the correct line for today. If a current record already exists for this week, the script figures out what day today is, and goes to that line of the start time repeating field. Note that the script correctly figures out the dB?ate the week starts, regardless of what day the file is opened. A List ViewB Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Begin Week End Week Start Time Lunch Hours End Time Work Hours Day Type Total This Week Hours Left Comments Week # First Name Total This Week Hours Left Comments Week # First Name Emp. ID Close View As View As Reports Record Delete Record Record Your Own Button Your Own Button K Enter data for Employee Timecard Standard Week (hrs) Today Y Timecards [ Last Name InformationB Yesfter Noarter Yesfter Noarter Close View As View As Reports Record Delete Record Record Your Own Button Your Own Button O6Click to see more information for an Employee Timecard Emp. ID First Name Week # Begin Week Total Hrs. d Last Name InfoF CloseG View As FormH View As ListI ReportsJ Your Own ButtonK Info for this Solution A0Information about the Employee Timecard solution Report MenuB InfoB CloseC View As FormD View As ListE ReportsF Your Own Button Timecard FormB InfoB CloseC View As FormD View As ListE ReportsF Your Own ButtonG>Click on any of these buttons to preview the respective reportH Timecard ReportI Your Own ReportJ Your Own ReportK Your Own ReportL Select a report n any of these buttons to preview the respective reportH Timecard ReportI Your Own ReportJ Your Own ReportK Your Own ReportL Select a report 9/18/95B 9/24/95D 7:30E 16:30 17:00 11:30G Regular Regular Sick DayI MondayJ TuesdayL WednesdayM ThursdayN FridayO SaturdayP SundayQ Sonia` 8/14/95B 8/20/95D 8:30E 18:30 17:30G Regular RegularI MondayJ TuesdayL WednesdayM ThursdayN FridayO SaturdayP SundayQ 16.75T Martin` Chester 9/25/95B 10/1/95D 7:30E 17:00 18:30G Regular RegularI MondayJ TuesdayL WednesdayM ThursdayN FridayO SaturdayP SundayQ Lunch meeting with clientsT Lorinda` Dobbs 11/20/95B 11/26/95I MondayJ TuesdayL WednesdayM ThursdayN FridayO SaturdayP SundayT InfoK CloseL View As InfoK CloseL View As View As ListN ReportsO Your Own ButtonU Start TimeW Lunch HoursY End Time[ Work Hours] Day Typef Commentsn Company Name and Logoo Timecard Formq Begin Weeks End Weekw Week #{ First Name} Employee # I5Please return completed form to personnel department. Rev. 09/29/95 Printed: // Employee Signature Manager Signature Total Hours Sort by Current Week Sort by Employee Name Timecard Report Open Script Open Script Cancel You did not enter any find criteria; all records will be displayed.C+ ) = 0 Cancel No records match this request.E) Sort by Employee Name Sort by Current Week Timecard Report Arial MS Sans Serif Helvetica Times Times New Roman wwwwww ffffff UUUUUU DDDDDD 333333 wwwwww ffffff UUUUUU DDDDDD 333333 wwffeffg@ veUEDDCC vUTDD44 vUDDC32 #""# weUDD3 veTDC2233#3#2 wUDDC3##" vUTD3#22 vUDDC fUD42233##3#"! vTDCC##" eUDC3223## fTD4C3##23#"" uTDC3323#2""! 22"2" ##2"! fTDD33#22"" vUDC32"2"" WUTC22 eTD3#"" GDC32"!! eD3#"! T32"" "%UR UD33D #4EWp "4EVx #3EVg "4DUg #3EVg "#4DVg 24EVgy "34EVw ##4Efw ""3DUgw ""33DUfw ""34DVgx ""#34EVgx "#33DEfw " 234DUfw 2""2334DEVgx 3 4DEUfwx 3 DDUVgw D EUUfwx UDDEUUfgw U Vfgwx eUVfgww wwwwww ffffff UUUUUU DDDDDD 333333 """""" wwxwwxw ggvgvv gvwxgwghg vhgvvww fvfgfwffv eVefefe VvffVefVVefUe\ ffFdeefeefddfDeVd fEdfFdffk EUeFFEUFEUFFUeTeVFeUUdVEEk UTdUTeETeETeEUFTUTUFTUUTeK TEETEETUETUETUDUDEETUDTUE[ 4CDD4E4ET DDCD4DD4CDDC C3C3C34C4C3CC43C "#""3"129 #11#22122"3! (LIST LISTA!Regular Holiday Vacation Sick Day VDEFA( dayTypes wwwwww ffffff UUUUUU DDDDDD 333333 """""" #11#22122"3! "#""3"129 C3C3C34C4C3CC43C DDCD4DD4CDDC 4CDD4E4ET TEETEETUETUETUDUDEETUDTUE[ UTdUTeETeETeEUFTUTUFTUUTeK EUeFFEUFEUFFUeTeVFeUUdVEEk ffFdeefeefddfDeVdfEdfFdffk eVefefe VvffVefVVefUe\ fvfgfwffv ggvgvv gvwxgwghg vhgvvww wwxwwxw AD@D@ AD@D@ AD@BL B"#B@ B"#B"$ 4"2$B"#B"#C 2$""#B"#C0 4"2#B"#C0 2$B"#C0 4""#C0 44444 CCCCC 44444 CCCCC $42" JJJJ !BBBB "99BB #9999 $9911 %1111 &)))) '!!!! *00**- *00-00 00*0) 00*&0# ## !0*!%00+#!*0##-0'"0*#%00.! UUUUU bRBBP0 @@BA@ (*)(%,3& )%+@6) ",30,)% #*>A6332+$"! 25,878 #&$690*" !)0,++)( "%/66435/'# +3;4*= !#,@9,)+,(""(-/,,* !$&(265389,#!$$ '275? " $$*23/$ $),-..)'' !$&)(-5439@1!!&*-3/)!!%6B) )220(!$*.,,.' !$&*,*023:?B+*.,/3254.' "++,3/(.584.," !#&+/-./3:9@G@60/16883)! $++//'(9CD>4.$$ $%)*-//2693,.075-&)3792,$ ")-1347<>@G71(! **)&'*.0350+%(=A2'%)579<94( +/11! !%'),342)1?=0)" .1,$',-01)*).AG6-/048:< /2583$%+66/% %)++*),+&%06,%$# !/40')-/31$$,@HFC<6887:==@B7%! 6A235,% +,/13.%#"(16+ !#$(04-$&+,+$ %2>D6,59:989889=0 ,.22<=33* .22671# !!&/42& *1$&+,/3779733, $$PQ /004B6* !$$ $))'/3) %&$&.7;4 )2$)*3-)466/%$ !),02+' %$5)%*+%$! (+'0:==4 $+,,1643"%)" !)/1)*+ +7=-%%&$! !3)3=. %&*/3113 !$$PQ ',4-%)/) ,6/%$$" +(!<- %),0354- .13-&,-* 14'$$! %))&%$! '3*$$" !&$%3 &%"%& 9836' )&#%%! $*)++" .-/:% !"&)()15, )" /.-+)! //6B& #'*,.42$ $/,-*% IF1A1 "%.2/-*#! $/.,*($!#$"%PQ #57-*'$#"$&' ..//.-,)'(.212PQ ",,)&%'.;<6/+',,)%! '//,+//*)+.4:=>PQ $(&(),5?@:2/,,''*$ -!,,%.0%)./7 #43((+9CA=3+,)+" &*)2!$96;;48@??PQ )/01%$ #3/').:@<3)$&)! /)4$%)8=A@?><@PQ !.0/.+//./1//* *.').3784/% ,,#%()25:<99=PQ %10// 0 /+134,.25653." )++-! # %0,*,384'%PQ 42//11/&(/563135650( (./36$ !"23.,27- 6:=<)&931-13-!$.69433563+ ,/258 #$,96-37)$!PQ 38;?B>;63/.22.-068934673( ,638<6$ *),/6."')==138*$)PQ 35:=@B>953-/1.-368<:8995& %668:9( )$'*.:&$*==8/, -19=@CA>:83+2.,0157: !""/88$ !)*# 6/0%&' !$*38,.<;60" +07=@CD=6>@.*)&(*-03;@@<- 6.3/% #/23989=2,*% /039>B@ "9E7,)+/3667:?CE/!" $$%199207/ 9K8@) 3933" !0042381%$(.-)56PQ 556:=@@ 5C958=BGGA96;='"+- !!%.94.6BDCFM='(204967& //2346% $59232$PQ :9<@?@C% 6D;;CJLONG952 (9304=FCDDE>% $,585' !.//11'$/;81$ 9:CE><D3,5G@@HF>IF94) $#%+*159C=:>FG) *31*# $/51# 89C=.!:9=C<9AFGCA7&( /%3%!'+5A<6=C>$ -672.3<<961.%! ,,%=<9/69/02. "773//33/,+) /1$'9< 069850(*)'% %/+$ !&##34 %0<PQ %"$:C9.*$ !+6@PQ "$$6CD>>5 !##() ".;CPQ %'0>GFA:378+&&%$$,& ,:CPQ $(,027CGG@6681//,)%$/ '7CPQ !%*/1,/44CC;6547@=2*!%.$ %;CPQ '$)=3 #%)*())3DLHB ?MB9/% ! "'6?6$ *;=PQ $%&,9D6 !$%#"&)-:FIJHFGFBN@91)%"#(,/./:/#$-46PQ !)/38;@( "$$!"+29?DGIJKMLEIC83)'&-7:73)%$!!,5:PQ +/0,$%&%%,26:5) "$%&(/7;<=BGIJIGMG=953'%(1<<63/! $*.8PQ 876=@?<3),3:8$ !&((),3=;::=EHIC:<F3)'""#&+/,', #&(0PQ FC8:CF@7/08<( "'()*, 169?:6=C=2..3'" "%&)PQ HD99=A@9534/ !26(%5, ! !),''*-16<@=430/,+/)! ??979>@@:-! !$+%-*),/37<@:2/-*)+*" 4?=95;@@9& *#%.,/136884/,)'),,%)+(%$$ />C:13?@9)$ !!89+ !)$%*-/13321/,*3*)-/0/+&$$! 6A:0,8B=1+)/68.%/(,9=2% ")$"%)-02331/31)/().241+%##! *79/)/:<651/33)2<8.6=9. !$%,56643/75,'&).340+&#!$$%#! .5.)/46682%#$$-973:=<7) !$'+4:964063+( ,33/+(&'),*)'# "%%.2379:1&"%(&.36@?@D5 !$%')/8:86>=2)&!!-231 34772+* &46339C@4+,3/)/:<D/8J=' "%'))+336@3(/)%#%,34569<=?CE5,)! #'21.7@C>9;99<9@CAE05J?,%$(.33/+,/26/)(,& #,0258<?ADGE2 "'(# "%),,/6983$ &4<9+4DD>?J>/*-6;<6,,/25.))3,' ",.0369;=AGE. !%%(,.040' 2A?EA4*+/683*.493/($!/-, 0246689:AC7% $%##(.23& :96,#"%)*(%(364, M4%"!!"560&)/<9;989;>3$ "03., PQ UUUUUU wwwwww UUUUUU wwwwww )=400 Cancel You did not enter any find criteria; all records will be displayed.C+ ) = 0 Cancel No records match this request.E) Sort by Employee Name Sort by Current Week Timecard Report Pro 3.0F! Pro 3.0M$ Description This database keeps track of employee hours, and is based on the standard employee timecard. How to use this solution Your employees can enter their hours directly into the database, or you can print blank Timecard reports for them to fill out and return. The database calculates the hours worked based on the start time, lunch duration, and end time. How to customize this solution You can add fields to calculate the employee's pay, based on the hours they worked and their paBfy rate. You can also track vacation and sick time, by adding a summary field for each time category.